CREATE TABLE [dbo].[AJUSTES_INV]
(
[ID] [numeric] (10, 0) NOT NULL,
[ID_USUARIO] [numeric] (10, 0) NOT NULL,
[ID_TIPO] [numeric] (10, 0) NOT NULL,
[FECHA] [datetime] NOT NULL CONSTRAINT [DF_AJUSTES_INV_FECHA] DEFAULT (getdate()),
[OBSERVACIONES] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_AJUSTES_INV_OBSERVACIONES] DEFAULT (''),
[ACTIVO] [bit] NOT NULL CONSTRAINT [DF_AJUSTES_INV_ACTIVO] DEFAULT ((1))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AJUSTES_INV] ADD CONSTRAINT [PK_AJUSTES_INV] PRIMARY KEY CLUSTERED  ([ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AJUSTES_INV] ADD CONSTRAINT [FK_AJUSTES_INV_AJUSTES_INV_TIPOS] FOREIGN KEY ([ID_TIPO]) REFERENCES [dbo].[AJUSTES_INV_TIPOS] ([ID])
GO
ALTER TABLE [dbo].[AJUSTES_INV] ADD CONSTRAINT [FK_AJUSTES_INV_USUARIOS] FOREIGN KEY ([ID_USUARIO]) REFERENCES [dbo].[USUARIOS] ([ID])
GO
